MacWorld 1996 July/Macworld (1996-07).dmg/System 7.5 Update 2.0/FileMaker Pro 3.0 CD Extras/FileMaker Templates/Business/Asset Management

FileMaker Pro Database | 1996-01-25 | 114KB | 645 lines

wwwwww
UUUUUU
DDDDDD
""""""
Equipment Rental & Usage
FileMaker Pro do
HBAM2016AUG95
Pro 3.0
Nov 9, 1995, 10:41 AM
ffffff
ffff33
ff33ff
ff3333
33ffff
HBAM3016AUG95
HP DeskJet 540 Printer
Pro 2.0 - 2.1F!
Pro 3.0
ASSET ID
ASSIGNED TO
BOOK VALUE
CATEGORY
CREATED BY
DATE ASSIGNED
DATE CREATED
DATE MODIFIED
DATE PLACED
DATE PURCHASED
DEP LIFE
DEPRECIATION
LOCATION
MODEL
PICTURE
PURCHASED FROM
REMAINING LIFE
SERIAL NUMBER
TOTAL BOOK VAL
TOTAL COST
     TOTAL DEP
Asset IDB
ItemB
CategoryB
CostB
Date PurchasedB
Date CreatedB
Date ModifiedB
Total CostB
Serial NumberB
Location
    USENG.NDX
Sunday
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
    September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
12/3/955
Description
This file helps you track office assets such as furniture, equipment, or any other depreciable item.  The file includes fields to input the serial number and purchase date of the asset.
How to use this solution
You can print an inventory report that you can use to complete your taxes.
How to customize this solution
The Item, Location, Assigned To, and Purchased From fields use value lists based on the their own contents. This means that every time you add a new value in any o
f those fields, the value is added to the pop-up list for the field, making it easier to enter that value in the future.
The Category pop-up menu is based on a pre-defined value list. To edit the value list, select the Category field in the Form View layout in Layout mode. Choose Field Format
 from the Format menu. In the pop-up menu of value lists, choose Define Value List
, and edit the list of categories.
Assigned ToB
Date PlacedB
Purchased FromB
Dep LifeB
Book ValueB
& <> 0
Remaining LifeB
& * 365 -
b)) / 365 > 0
& * 365 -
b)) / 365
Total Book ValB
DepreciationB
-A    Total DepB
PictureB
Date AssignedB
InfoB
Created ByB
A    List View
Inventory Report
Information
Report Menu
Depreciation Report
@4A    Form View
A    List ViewB
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
Inventory ReportB
Your Own
ButtonW
Your Own
ButtonX
RecordY
Delete
RecordZ
Record[
Reports\
View As
List]
View As
Form^
Close_
Info`
Locationa
Assigned Tob
Serial No.c
Modeld
Iteme
Category
f*Click to see more information for an Asset
InformationB
Your Own
Buttonw
Reportsx
View As
Listy
View As
Formz
Close{
Info|
Page ##~
Asset Inventory Report
Category
Date Placed
Location
Serial Number
Assigned
Model
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO%Information about the Assets solutionP
Info for this Solution
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
InfoG
Your Own
ReportH
Your Own
ReportI
Depreciation ReportJ
Inventory ReportK>Click on any of these buttons to preview the respective reportL
Select a report
Your Own
ReportI
Depreciation ReportJ
Inventory ReportK>Click on any of these buttons to preview the respective reportL
Select a report
Depreciation ReportB
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
A    Form ViewB
Your Own
Button
Reports
View As
View As
Close
Deprec.
Grand Totals:
J    Rem. Life
K    Dep.
Value
Page ##
Asset Depreciation Report
Serial Number
Model
Sort by Assigned To
Depreciation Report
Open Script
Your Own
Buttonx
Your Own
Buttony
Recordz
Delete
Record{
Record|
Reports}
View As
List~
View As
Close
Depreciation
Depreciation
Book Value
Remaining Life (years)
Depreciation Life (years)
Date Placed in Service
Date Purchased
Purchased From
Acquisition
Location
Assigned To
Assignment
Picture
Category
Model
Serial No.
Asset ID
Asset
Enter data for Assets
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
) = 400
Cancel
You did not enter any find criteria; all records will be displayed.C)
Cancel
No records match this request.E)
Sort by Category
Sort by Assigned To
Inventory Report
Depreciation Report
Open Script
Sort by Category
Inventory Report
Sort by Assigned To
Depreciation Report
Open Script
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
(LIST
LISTA0Office Furniture
Computers
Telephones
Vehicles
VDEFA(
(LIST
VDEFA(
(LIST
VDEFA(
(LIST
VDEFA(
(LIST
VDEFA(
Category ListB
Assigned To ListC    Item ListD
Location ListE
Purchased From List
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
wwwwww
UUUUUU
DDDDDD
""""""
wwwwww
    ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
"    234DUfw
2""2334DEVgx
3    4DEUfwx
wwwwww
    ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
"%UR
UD33D
3    DDUVgw
D    EUUfwx
UDDEUUfgw
U    Vfgwx
eUVfgww
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
AD@D@
AD@D@
44444
CCCCC 44444 CCCCC
$42"
@@BA@
bRBBP0
 JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))C
'!!!!
 *00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
UUUUUU
wwwwww
(*)(%,3&
)%+@6)
",30,)%
 #*>A6332+$"!
25,878
#&$690*"
!)0,++)(
 "%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*
!$&(265389,#!$$
'275?
" $$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
 $$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
 !$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+,)+"
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!PQ
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGCA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
 %'0>GFA:378+&&%$$,&
,:CPQ
$(,027CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
 #%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
876=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,
169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,*3*)-/0/+&$$!
 6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7)
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
 &46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
 #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,M4%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
CWF_Mono
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
ModelB
ItemB
CategoryB
CostB
Date PurchasedB
Date CreatedB
Date ModifiedB
Total CostB
Serial NumberB
Location